<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>WIKINDX CLASS DOCUMENTATION</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/wikindx2/docs/docs.css" type="text/css" />
</head>

<body bgcolor="#FFFFFF" text="#000000">
<h2>WIKINDX METHODS</h2>
<p><strong>Method:</strong><br />
  
  updateNull()
</p>
<p><strong>Class:</strong><br />

  <a href="sqlClass.html">SQL</a>
<p><strong>Method Call:</strong><br />
  include_once("core/sql/SQL.php");<br />
$db = new SQL();<br />
STRING $db->updateNull(STRING: $table, ARRAY: $setArray, [STRING: $condition]); </p>
<p><strong>Description:</strong><br />
   Execute an UPDATE statement setting the required fields to <em>NULL</em>.</p>
<p>$setArray is an array where each field is a field within $table that is to be set to <i>NULL</i>. </p>
<p> Do not add backticks, single-quotes etc. - the SQL class will do this automatically depending on the database we're connected to. </p>
<p></p>
<p><strong>Usage:</strong><br />
  For example (assuming the database object exists within a class as $this->db):
<pre>
	$table = "WKX_resource";
	$setArray = array(
		"title",
		"subtitle",
		);
	$condition = "WHERE " . $this->db->formatField('id') . "=" . $this->db->tidyInput(666);
	$this->db->updateNull($table, $setArray, $condition);
</pre>

</p>
</p>

<p align="right"><a href="../../index.html">WIKINDX home</a>
&nbsp;&nbsp;&nbsp;&nbsp;
<a href="../../usage/index.html">WIKINDX usage</a>
&nbsp;&nbsp;&nbsp;&nbsp;
<a href="../index.html">WIKINDX classes</a>
</p>
</body>

</html>
